Table: Item Pricing

Table: ICPRIC
View: IC0480
Record length: 410
Flags: A R 

Keys: 3

Title  Flags  Fields

Currency Code   CURRENCY, ITEMNO, PRICELIST
Item Number   ITEMNO, CURRENCY, PRICELIST
Price List Code   CURRENCY, PRICELIST, ITEMNO

Fields: 47

Field  Type  Title  Presentation 

CURRENCY  String*3  Currency Code  Mask: %-3N
ITEMNO  String*24  Unformatted Item Number  Mask: %-24C
PRICELIST  String*6  Price List Code  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DESC  String*60  Description   
PRICEDECS  Integer  Decimals in Price  List: 7 entries
0= 0
1= 1
2= 2
3= 3
4= 4
5= 5
6= 6
BASEPRICE  BCD*10.6  Base Price   
BASEUNIT  String*10  Pricing Unit of Measure  Mask: %-10c
BASECONV  BCD*10.6  Base Conversion Factor   
SALEPRICE  BCD*10.6  Sale Price   
SALEUNIT  String*10  Sale Unit of Measure  Mask: %-10c
SALECONV  BCD*10.6  Sale Conversion Factor   
SALESTART  Date  Sale Start Date   
SALEEND  Date  Sale End Date   
MARKUPCOST  BCD*10.6  Markup Cost   
MARKUPUNIT  String*10  Markup Unit of Measure  Mask: %-10c
MARKUPCONV  BCD*10.6  Markup Conversion Factor   
PRICETYPE  Integer  Selling Price Based on  List: 8 entries
1=Discount
2=Markup on Markup Cost
3=Markup on Standard Cost
4=Markup on Most Recent Cost
5=Markup on Average Cost
6=Markup on Last Unit Cost
7=Markup on Landed
8=Markup on Alt.Amt.2
PRICEFMT  Integer  Discount/Markup Price by  List: 2 entries
1=Percentage
2=Amount
PRCNTLVL1  BCD*5.5  Discount/Markup Percentage 1   
PRCNTLVL2  BCD*5.5  Discount/Markup Percentage 2   
PRCNTLVL3  BCD*5.5  Discount/Markup Percentage 3   
PRCNTLVL4  BCD*5.5  Discount/Markup Percentage 4   
PRCNTLVL5  BCD*5.5  Discount/Markup Percentage 5   
PRICEBASE  Integer  Price Determined by  List: 2 entries
1=Customer Type
2=Volume Discounts
PRICEQTY1  BCD*10.4  Quantity Level 1   
PRICEQTY2  BCD*10.4  Quantity Level 2   
PRICEQTY3  BCD*10.4  Quantity Level 3   
PRICEQTY4  BCD*10.4  Quantity Level 4   
PRICEQTY5  BCD*10.4  Quantity Level 5   
MARKUP  BCD*5.5  Markup Factor   
LASTPRICDT  Date  Last Price Change Date   
PREVPRICE  BCD*10.6  Previous Price   
LASTMKPDT  Date  Last Markup Cost Change Date   
PREVMKPCST  BCD*10.6  Previous Markup Cost   
LASTEXCHDT  Date  Last Exchange Rate Change Date   
PREVEXCHRT  BCD*8.7  Previous Exchange Rate   
ROUNDMETHD  Integer  Rounding Method  List: 3 entries
1=No Rounding
2=Round Up
3=Round Down
ROUNDAMT  BCD*10.6  Round to a Multiple of   
AMOUNTLVL1  BCD*10.6  Discount/Markup Amount 1   
AMOUNTLVL2  BCD*10.6  Discount/Markup Amount 2   
AMOUNTLVL3  BCD*10.6  Discount/Markup Amount 3   
AMOUNTLVL4  BCD*10.6  Discount/Markup Amount 4   
AMOUNTLVL5  BCD*10.6  Discount/Markup Amount 5   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.